var sqlMap = {
    phone: {

    },
    order: {
        check: "select `order`.order_id,phone.phone_type,`order`.order_state from `order`,phone where `order`.customer_id = ? and phone.phone_id = `order`.phone_id and `order`.order_state like '%货%'",
        cart: "select `order`.order_id,phone.phone_type,`order`.order_state from `order`,phone where `order`.customer_id = ? and phone.phone_id = `order`.phone_id and `order`.order_state = '未付款'",
        pay: "update `order` set order_state = '未发货' where order_id = ? and customer_id = ?",
        delete: "delete from `order` where order_id = ? and customer_id = ?",
    },
    customer: {
        login: 'select customer_id,customer_name from customer where customer_account = ? and customer_password = ?',
        signup: 'insert into customer(customer_account,customer_password,customer_name) values (?,?,?)',
        checkAccount: 'select customer_id from customer where customer_account = ?'
    },
    admin: {
        selectAllCustomer: 'select * from customer',
        selectAllOrder: 'select `order`.order_id,customer.customer_id,customer.customer_name,phone.phone_type,`order`.order_state from `order`,customer,phone where `order`.customer_id = customer.customer_id and `order`.phone_id = phone.phone_id',
        selectAllProduct: 'select phone_id,phone_brand,phone_series,phone_type from phone',
    }
}
module.exports = sqlMap;
